Risc World 3

home *** CD-ROM | disk | FTP | other *** search

/ Risc World 3 / Risc World 3.iso / SOFTWARE / ISSUE4 / POWERBASE / DOCS / _Index < prev next >

Wrap

Text File | 2001-03-16 | 18.4 KB | 629 lines

===== Index ===== !BMARGIN 55 !BODYFONT 55 !CASE 54 !CHANGE 56 !CLEAR 54 !COMMENT <string> 54 !COPIES 55 !CSV 54 !DATE 55 !DELETE 56 !DESTINATION 55 !EXCLUDE 54 !EXPAND 55 !FILTER 56 !FIRST 55 !FONTSIZE 55 !FORMAT 55 !HEADER, !FOOTER 55 !HEADERFONT 55 !HEADINGS 55 !IMPRESSION 55-56 !INCLUDE 54 !INDEX 56 !INSERT 56 !KEY 56 !LABEL 55 !LINESPACE 55 !LMARGIN 55 !MESSAGE 54 !MOVE 56 !OBEY 56 !ORIENTATION 55 !PAGE 55 !PMARGINS 55 !PRINTOPTS 54 !QUERY 54 !RMARGIN 55 !SAVE 54 !SCRIPT 54 !SELECTION 54 !SHRINK 55 !SORT 55 !SPACER 55 !STARTAT 56 !SUBFILES 54 !TABLE 55 !TEXTWIDTH 55 !TITLE 55 !TMARGIN 55 !UPPER 55 A = Access-control list 52 Accumulating records in one subfile 13 Add record button 10, 58, 65 Adding new records 10 Allowed list in validation table 36-39 Alphanumeric fields 29 Altering existing records 11 Analysing Date fields by month 26 Analysing indexed fields 26 AND in search formulae 20 AND, OR and NOT in Help window 23 Application shell, creating 27 Archives, unpacking 5 Arithmetic in search and replace 13 Arithmetic on report columns 42 Arrow keys, action when editing 10 Auto-balancing of indices 51 Average, calculation for numeric column 42 B = Balancing indices 51, 60 Batch deletion and moving of records 13 Binary Large Objects (BLOBs) 30 Blanking records on deletion 59 “Bookmarks”, use of to mark place in file 8 Bounding box of field, moving and re-sizing 28 Browsing 8 Button fields on record window 32, 58 C = Calculated fields 40-42 Calculation formulae 42 Calculations, general discussion 40 Calculations involving dates 41 Calculations involving times 41 Calculations, making retrospective 40 Case of letters and indexing 35 Case switch (on Query panel) 19, 26 Case switch (on Preferences window) 59 Case-sensitive queries 19, 59 Changing keys 8 Changing many records at once 12 Changing size of database 46, 51 Changing subfile 9 Check Boxes 18, 27, 30, 42, 47 Check boxes, 3-state 18, 30 Check boxes, appearance in reports 18 Choosing which fields to print 18 Clipboard, global 12 Clipboard, use of 12, 65 Closing a database 6 Collecting records in one subfile 13 Colours used to identify key fields 8, 61 Colour used to identify linked fields 37, 61 Colour used to identify mandatory fields 33, 61 Colours window 8, 33, 37, 61 Column calculations 42 Column headings in reports 25 Column spacer 25 Comma, literal, including in search formulae 19 Compacting sequence numbers 32 Comparators in search formulae 19-20, 23 Comparators, list of 20 Comparison by numeric value, forcing 21 Composite fields 41 Computed fields 18, 27, 31, 40-42, 59 Concatenation of fields 17, 45 Confidential data 13-14 Config files, description of 61-62 Config files for individual databases 62 Copy and Paste buttons 12 Copying a field to the clipboard 12 Copying fields 12 Counting matching records 23 Counting values in column 42 CSV data, truncation of 46 CSV field separator 44 CSV file, conversion to functioning database 47 CSV file, edits saved as 59 CSV files 14, 28, 38, 44-48, 51, 53, 57-58 CSV files, description of 44 CSV files from scrollable lists 15 CSV files from validation tables 38 CSV files, importing into scrollable lists 15 CSV files, importing into validation tables 38 CSV header record 44 CSV line terminator 44 CSV options 44-45, 47, 58-60 CSV options, importance of 45 CSVoptions file 59 D = Data length for record field 27-28, 32, 50 Data length in scrollable lists 30 Data Merge window 49 Data overflow during CSV import 46 Data underflow during CSV import 46 Data-Merging with other applications 48, 60 Database 33, 43 Database file 7, 14, 31, 50, 59 Database size 33, 46, 51 Database, adding new fields 50 Database, reformatting 50 Database, renaming 35 Database, shortening using subset 57 Date fields 26, 29, 31 Date and time fields 31 Date separator 59 Date stamp fields 26, 32 Date stamp10 fields 32 Date stamp8 fields 32 Date stamp in report header 25 Day-of-week stamp field 31 Default database, creating 33, 27 Default print options file (!PrintOpts) 26 Default Query file (!Query) 26 Default selection file (!Selection) 18 Delete button 11, 65 Deleting a batch of records 13 Deleting fields during record design 28 Deleting records 11 Descriptors 17, 27-29, 43-44, 46, 50, 55, 59, 61 Dial-tones, generating from records 62 Directory button 32 Directory button, unlinking 33 Disabling certain types of functionality 53, 58 Displayed record, exporting 24 Displayed record, printing 24 Doubled comparators in search formulae 20 Draw files in external fields 14, 30-31 Duplicate keys, warning of 60 Duplicate primary keys, listing of 51 Duplicate primary keys, prohibiting 53 E = Editable fields 18, 27, 33 Editing scrollable lists 15 Editing, choosing starting field 12, 60 Email address for Powerbase Support 5 Empty database, building 35 Exact match in table validation 37, 38 Excluding individual records from reports 24 Exit button on record window 32 Expanding data using validation table 25, 39 Expanding report headers 25 ExpandCode (Impulse command) 63-64 Exporting data as CSV files 45 Exporting subsets of records 57 External fields 11, 14, 27, 30-31, 46-47, 60 External fields, editing 14 External fields, exporting 14 External fields, linking files to 14 External fields, pathnames of files 62 External fields, unlinking 14, 31 External fields, warning of deletion from 60 Extra button fields on record window 32 F = “Fast forward” button 8, 65 “Fast forward” interval 8 “Fast rewind” button 8, 65 Field, meaning of 7 Field concatenation 17, 49 Field creation in record design 27 Field Definition window 27-28, 50 Field selection for creating reports 17 Field separator in CSV files 44 Fields, copying 12 Fields, making invisible and inaccessible 13 Fields maximum number allowed 61 Fields, printable types 18 Fields, re-ordering 28 File destination for reports 16 File (CSV), conversion to working database 47 Filters 9-10, 65 Filter switch 19, 65 Filetype &7f3, “S” for print Selection 18 Filetype &7f4, “Q” for Queries 22 Filetype &7f5, “P” for Print options 26 Final record button 8, 65 First record button 8, 65 Fixed data on new records 11 Flashing field, meaning of 9 Footers in reports 25, 42, 55 Force update button 11, 37, 43, 60, 65 Form file 33, 50 Formats for reports 16 Function keys 7, 53, 58 Function keys, assigning 58 Function keys, disabling 53, 58 Function keys, storing strings in 58 G = GetExpanded (Impulse command) 63-64 GetField (Impulse command) 63 GetPathname (Impulse command) 63 GetRecord (Impulse command) 63 Global changes 12-13, 19 Global clipboard, support for 12 Grid for designing record layout 27, 50 H = Hardware requirements to run Powerbase 5 Headers in reports 25, 46, 55 Header record in CSV file 45, 47 Help application 6 Help available within Powerbase 6, 23 Help window for constructing search formulae 23 Helpreader text 6 Hiding sensitive data 13 Horizontal format for reports 16-17, 25, 55 Hyphen in search formulae 20 I = I.D.s and personal passwords 52 Iconbar menu 58 Iconbar menu, disabling 53, 58 Importing data from CSV files 45 Importing data from plain text files 46 Impression, merging data into 48-49, 56, 60 Impulse commands 48-49, 60, 63-64 Including individual records 24 Inclusive search 20 Index, case-sensitive 35 Index, analysing 26 Indexing a field 43 Indices 7-9, 11, 25-27, 35, 43, 50-53, 59-60 Indices directory 27, 43 Inserting fields when designing record 28 Installing Powerbase 5 Internet − special field type 29 Invisible fields 13 K = Key fields 7-10, 33-35, 61 Key Structure 33-35, 43, 50 Key structure of the currently-active index 9 Key structure, examples 34-35 Key structure, multiple fields in 35 Key, explanation of 7 Key, inclusion in reports 23 Keypad 7-12, 19, 32, 37-38, 43, 52-53, 58, 60, 65 Keypad buttons as record fields 27 Keypad, disabling 53, 58 Keys 7-9, 34-35, 51, 53, 58, 63 Keys Maximum number 61 Keystrokes 7, 58 L = Label format 17 Labels, including primary key 17 Labels, number of lines printed 17 Labels, substituting for blank field 17 Labels, using up part sheets 17 Last altered (stamp field) 32 Launch new copy 59 Line spacing, for tables 17 Line-spacing 17 Linked fields 61 Linking tables to fields 37 List values button 10, 37-38, 65 Loading Powerbase 5 Loading validation tables 39 Logging changes 53 Log file 53 Logo fields 31-32 Lookup function 8 M = Mail-Merging 48-49 Main menu, disabling 53, 58 Manager access rights 14 Manager password 52 Mandatory fields 10, 33 Mandatory fields, colouring of 33 Margins in reports 16, 25, 55 Marking records for printing etc. 24 Marking records with “bookmarks” 8 Match window 18-19, 23-24, 32, 54 Matches found during key search, number of 9 Maximum value in column of numbers 42 Maximum value in numeric fields 29 Menu button on screen 33 Menus directory for user menus 27, 33 Merging databases 51 Messages file 62 Minimum value in numeric fields 29 Minimum value in column of numbers 42 Month of year stamp field 32 Months breakdown for Date fields 26 Moving a batch of records 13 Multi-criterion searches 20 Multiple subfiles, use of 9 Multitasking within Powerbase 61 N = Naming subfiles 9 New fields, adding to database 50 New record format 50 Next key button 8, 65 Next record button 8, 65 Next subfile button 9, 65 NextMatch (Impulse command) 63-64 NOT in search formulae 20 Null keys in subsidiary indices 43 Null tags, where permitted 29 Numeric fields 13, 25, 29, 35-36, 40-42 Numeric fields in search formulae 21 Numeric fields, justification of 17 Numeric min., start value for Sequence no’s 32 O = Old button on Query panel 19 Old button on Search window 10 Open button on Access window 6 Opening a database 6 Options, CSV 44 Options, print 16-17, 23-25 Order of fields in reports 18 OR in search formulae 19-20, 26 Output destination for reports 16 Ovation, mail-merging with 48-49 P = Page length in reports 25 Page numbers in reports 25 ParseQuery (Impulse command) 63 Password protection 6, 50, 52-53, 58, 61 Paste from Clipboard 12 Personal I.D.s and passwords 52 Picture fields 14, 30-31 Place in subfile, storing 60 Play button 8 Pop-up menu 33 Powerbase, versions and compatibility 5 Preferences 10, 38, 43, 51, 53, 59-60 Preferences window 29 Previous key button 8, 65 Previous record button 8, 65 Previous subfile button 9, 65 Primary key 7-8, 11, 17, 27, 33-35, 43, 47, 50-51, 53, 60-61, 63 Primary key index 7 Primary key, defining structure 33 PrimaryKey file 33-35, 43, 50 Print button (on screen) 32 Print destination 16-17, 23, 25, 54-56, 62 Print formats 16-18, 24-25 Print Options 16, 24, 26, 39, 44, 46, 58-59 Print options files 26 Print options window, displaying 23-24 Print Resources 18 Print selections 18 Printable fields 18 Printer destination 16 Printing arbitrary selection of records 24 Printing from a Report window 16 Printing order of selected fields 18 Printing speed 26 PrintJobs directory 16, 27, 38, 45-46, 54, 57, 65 PrintRes directory 18, 27, 65 PutRecord (Impulse command) 63-64 Q = Query by example (QBE) 19, 22-23 Query by example, limitations of 22-23 Query file, default 21 Query files 22 Query panel 19, 23, 26, 45, 54, 57 Quit button on record window 32 Quitting Powerbase 6 Quotation marks in CSV files 44 R = RAM disc 5-6 Random selection of records, printing 24 Re-ordering fields during record design 28 Read password 52 Read/write password 52 Recalculate on opening 59 Record edits as CSV file 59 Record format, minor adjustments to 50 Record layout, designing 27 Record numbers 7, 31 Record numbers, inclusion in reports 23 Record, copying fields 58 Record, copying entire 12 Record terminator in CSV file 44, 45-46 Record window 7, 9-10, 14, 27-28, 30-32, 35, 39, 45-47, 49, 58, 60 Records, filtering 10 Records, retrieving by key 9 Records, retrieving by record number 10 Records, retrieving via Report window 16 Records, searching all subfiles for 10, 58 Records, searching for 9 Related records, accessing 8 Remote fields 14, 30-31 Removing fields during record design 28 Renaming a database 35 Re-ordering fields during record design 28 Replace-on-entry (validation tables) 37-38 Report printing 16, 53 Reporting, disabling 53 Reports, formats for 16 Resources 61 Reverse order for reporting 19 Reverse switch on Query panel 19 Rewind button 8, 65 Rotate button 9, 65 Rotating subfiles 9 Run file button on record window 32 Run file button, unlinking 32 S = Save box 16, 27, 38, 58 Saving from a Report window 16 Saving a print selection 18 Saving a query for future use 21-22 Saving print options 26 Script commands 54-56 Script files 46, 54-56, 59 Script language 54 Scrollable list, adding rows 15 Scrollable list, clearing 15 Scrollable list, deleting rows 15 Scrollable list, exporting from 15 Scrollable list, importing to 15 Scrollable lists 18, 24, 27, 29 Scrollable lists and CSV files 45 Scrollable lists and validation tables 37 Scrollable lists, editing 15 Scrollable lists, maximum number of 61 Scrollable lists, printing format 25 Scrollable lists, rows visible 30 Scrollable lists, unequal columns in 30 Scrollable lists, where to use 29 Search all subfiles 58 Search and replace 12 Search button 9, 58, 65 Search element 19, 23 Search formula 10, 12-13, 18-23, 25, 27, 45, 54, 57, 63-64 Search formulae and Help window 23 Search window 9-10 Searching for individual records 9-10, 43 Searching by filter 10 Selection (Impulse command) 63 Self-calculating fields 40, 42 Separator in CSV files 44-45 Sequence number fields 31 Shift back button 11, 65 Shift forward button 11, 65 Shift record forward or backward 11, 65 Shrinking reports (removing white space) 16, 25 Snap interval for record-design grid 27 Sorting 16, 38, 43 Sorting a validation table 38 Sorting lines in a Report window 16 Sorting, specifying before printing 17 Spacer between columns of reports 17, 25, 45, 55 Speeding up printing 26 Sprite files in External fields 14, 18, 30-31 Stamp fields 18, 27, 31-32 Stamp fields, equivalent Computed types 32, 40, 59 Standard deviation, calculation for column 42 Start editing at specified field 12, 60 Stop button 8 Strip leading and trailing spaces 60 Subfile number, inclusion in reports 23 Subfile rotation 9, 65 Subfiles 7, 9-10, 40, 50-51, 53, 60, 65 Subfiles, explanation of 7 Subfiles, naming 9 Subfiles, printing from several 23 Subset database 19, 24, 51, 53, 57 Subsidiary indices 26, 43, 53 Subsidiary keys 7-8, 43 Sum of numbers in report column 42 Swap with button (field definition window) 28 T = Table format for reports 17, 25, 55 Tables, maximum number permitted 61 Tag list in search formula 19 Tags 19-20, 23, 27-28, 34, 40-41, 43-44, 46, 48, 50, 55, 63 Tags, importance of 28 Target list in search formula 19 Template, use in data-entry 11 Terminator in CSV files 44-45 Text block 14, 17-18, 25, 28, 30-31, 46 Text button on record window 14 Text files in External fields 14, 30-31 Text width in Vertical format 17, 25 Three-state check-boxes 18, 30 TIME$ in user functions 40-42, 59 Time entry, interpretation of 62 Time fields 29, 31, 41 Time fields, calculations on 41 Time fields, interpretation of input 29, 62 Time fields, separator in 59 Time for report creation 26 Time Stamp fields 31-32 Times, how displayed 62 Title on reports 25 TooBig file and CSV import, explanation of 46 TSV files 44 U = Undo facilities 11, 13, 38 Undoing mistakes 11 Unlinking objects from External fields 31 Unlinked validation tables, how to load 39 Unrestricted input fields 29 Upper case in reports 25, 29 User functions 41-42, 59 User menus, defining 33 User menus, where stored 27, 33 UserFuncs file 42 Using CSV files to modify existing records 47 Using more than one subfile 9 UsrSprites file 32 V = Validate input button (Preferences) 10, 59-60 Validation 10-12, 25, 36-39, 41, 43, 52, 55, 59-60, 64-65 Validation string in ValStrings file 36 Validation table, creating Validation table data in printouts 39 Validation table, displaying 38 Validation table, saving contents as CSV file 38 Validation tables, exact match with 37 Validation tables, loading unlinked 39 Validation tables, replace on entry feature 37 Validation, turning ON/OFF 60 ValStrings file 36 ValTables directory 27, 38-39, 65 Vertical format for reports 17, 25, 55 W = Website for information & upgrades 5 “White space” in reports, removing 16, 25, 55 Wild cards in search formulae 21 Wild cards in search-and-replace 13 Wild-cards, characters used to represent 59 Window destination for reports 16 Writable icons, copying between 12 Write password 52 Y = Year stamp field 32 Yes/No/Maybe fields 29